SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002968s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532509 LIMIT 1 [ RunTime:0.002591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532509 [ RunTime:0.009712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41764,551357,8386,376734,412560,4959,762044,875854,891142,945411,307576,28993,275376,295886,1021640,813286,520329,197997,480560,37438,333170,235230,552471,928278,554075,609311,1017137,753845,663350,652255,586670,882977,313388,999351,65040,153024,789441,84280,235561,692085,36771,801945,679081,936256,680323,890599,676069,361437,583470,538271,285425,19560,474812,862160,555702,1002441,696820,1020752,805409,44152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007477s ]