SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417315 LIMIT 1 [ RunTime:0.001208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417315 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97713,277207,855748,713707,1023451,187776,58633,974172,907320,225874,24534,256552,707016,440903,754016,720017,863273,285854,986560,737482,433065,763548,65956,897422,885215,953124,229415,252160,168450,299618,282240,134240,845128,135659,893839,315405,325442,176133,486948,85167,392296,927071,349400,867617,980651,495961,566222,204180,915190,120486,285862,89300,455299,969442,107908,888750,783720,487463,348508,627587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003518s ]