SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518511 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518511 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162164,133384,72787,965709,905626,16661,704978,577906,978113,124333,193165,241530,1017761,235468,581260,211504,774531,587466,352248,461281,701105,608121,686168,92085,468005,750432,836605,423805,911021,140635,260197,687422,417310,504195,14231,88735,481420,211698,601120,571246,1041094,826939,934866,322785,373046,687954,806649,87277,884316,333848,291714,767348,404694,228398,1038299,181778,309913,1036217,160384,876976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]