SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012803 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012803 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676063,433310,347417,464839,251656,885380,610494,850132,1020285,1032581,337761,1030222,35944,920682,567271,386513,863193,343631,673621,46703,620522,677451,1037284,639439,384725,241087,238909,96855,623639,98354,801619,248139,490526,494043,11508,831993,256677,117449,249594,924781,107694,590865,430584,814718,236302,815483,258104,1014798,607948,626832,414427,802791,998023,386651,794257,348067,507588,785976,517641,173076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]