SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30522 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30522 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224333,954903,352785,597540,762340,678573,662772,328748,472970,990388,445014,787675,103653,708186,620408,404889,400144,217840,651884,541512,342153,267971,290254,191206,509827,151583,59174,1002137,337627,323681,699751,102166,979350,513726,589655,281677,773092,576684,420793,598468,253412,770563,266011,549237,374105,449317,894625,746240,770736,192048,1047781,270585,996438,244094,75622,448327,687476,279559,619747,174143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]