SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395412 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395412 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533776,706720,1015975,165180,159162,625719,446020,168602,1028891,14958,791176,954482,41470,484130,951140,627578,32103,913121,330357,172937,298487,665561,590759,757233,607293,867742,1035423,613560,528717,676930,480182,730208,71659,959619,195795,15479,755478,160362,942094,260039,142853,778234,468677,939737,705306,623172,787834,245556,586107,588566,17293,921467,622137,789134,1038393,157895,268933,116937,335697,17516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]