SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255546 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255546 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39541,3635,411653,990665,380841,425663,780532,179839,107650,653501,93641,402672,498849,965333,992976,687090,100098,19062,427673,174358,550845,258653,428986,875930,989460,625967,986092,684134,13553,911845,985271,179662,88109,728362,620810,174766,628872,127407,555336,402219,208278,446774,429904,925003,778119,269862,552128,134426,644128,490568,875449,988388,461366,452636,677917,177167,796791,316481,146308,917203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]