SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429785 LIMIT 1 [ RunTime:0.001153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429785 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323788,421313,336788,51654,422573,619256,569122,400734,544068,130763,480075,965569,299125,718943,111328,500534,310844,1037842,103628,861482,361678,648405,130794,402515,496185,352315,240834,748556,584156,369444,1013105,98664,786001,794161,242073,515951,218239,344996,729192,532000,203418,177102,689988,790900,906962,983722,266824,221542,389248,311305,523166,190383,699834,523841,772982,757764,1037114,814578,537936,107403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002186s ]