SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542803 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542803 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700599,588356,202520,316549,804818,321370,722779,33194,572520,548490,800007,296116,120566,731458,887243,226416,418393,600408,229734,664858,839929,972245,560752,336678,474256,1006365,557229,279853,861675,495677,582482,347593,286629,603261,664487,961918,289920,805286,376080,94427,431846,94990,126185,383337,632859,313758,504411,775645,143527,238847,376878,520504,64971,984477,682857,76025,142352,373537,932934,931013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]