SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413450 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413450 [ RunTime:0.004581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665821,584751,35223,386203,490059,869421,922723,663581,116243,285731,958116,959716,1016680,689940,383845,71621,1026573,1024421,210732,1043726,351063,617253,716420,525708,618405,412209,201411,813327,457091,224309,220624,611752,883929,293654,991151,390644,380277,462586,651917,129213,380356,194866,146960,800999,1036132,241170,150748,1035482,869998,930387,24032,687528,946427,52058,636944,1042418,429492,237256,952380,515014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]