SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643801 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643801 [ RunTime:0.003168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809038,337914,982527,698889,497742,174996,422620,400162,553386,979758,240809,19567,798482,869960,563689,676439,34764,773091,781624,357062,670267,201947,750486,551080,663983,361149,636031,485860,231398,122875,368195,906553,28474,507229,63211,870687,484088,627477,2461,126840,424696,486175,281009,361669,656827,35379,608,148837,68982,162769,1030608,727589,182247,867571,913299,511263,732721,557797,600492,230878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]