SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201091 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201091 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176489,838459,962639,219820,717192,846990,93799,688137,155483,527921,763475,382510,785123,108024,833034,709564,67647,118329,699867,307108,801423,95659,499452,844949,464146,549478,662971,862667,551770,929189,411899,55418,326409,638552,944064,15395,293507,531504,550259,355169,640098,696430,198221,423127,81198,167726,1038377,304976,515892,677626,587309,418788,1017045,115269,145636,938279,695066,729132,769172,552631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]