SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445164 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445164 [ RunTime:0.002942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927297,826964,322484,206080,277053,4316,362803,806235,935131,197097,1021177,129867,258075,426893,317362,68071,506619,765641,127729,444463,231707,866246,546717,120320,605935,457380,210885,670682,493085,775145,417937,875664,656313,574865,504367,91948,155374,380753,695210,361618,106995,868624,570224,592444,449766,307378,48437,239685,974762,207937,107129,300371,98790,363771,969498,1026841,881096,721023,59110,703215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]