SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004987 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004987 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724743,402657,59114,120945,988701,938346,594702,546765,63928,527517,941520,252664,472040,45094,737215,393161,39015,273042,187949,576324,637837,529287,1039563,986994,31843,976243,39066,174449,890865,587509,530893,110555,905255,428486,901033,436781,482752,335371,969927,78323,287115,336681,261489,476537,468828,82029,286050,359478,270615,981614,456014,106863,398288,648808,1004390,350077,844665,125248,436809,177982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]