SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106022 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106022 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282020,928480,609629,571839,157274,555787,398567,803813,985525,329568,304932,50434,453563,959160,484203,118002,1007182,750449,768221,696181,330362,133513,671232,147825,373477,837072,967214,1003950,163878,506805,256108,394829,269773,428956,332899,5053,806606,842985,119073,362061,622220,329431,829270,457959,58764,527422,181148,669081,315866,456196,503195,551801,83241,236564,896386,440287,118035,309774,454996,519523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001465s ]