SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269312 LIMIT 1 [ RunTime:0.001433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269312 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332875,63310,774548,216740,895745,1016931,318394,463737,404732,1009119,931978,375945,511778,14344,926144,677292,817151,497973,589063,795234,291747,662389,227986,42863,362117,485982,299303,232328,898835,643725,1039011,324231,751102,870421,346837,730242,973684,85413,224247,1026034,296569,466858,363116,497469,102636,64150,722465,91054,100241,82247,190368,801595,988965,777572,311085,724068,248760,782888,448952,770712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]