SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 864073 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 864073 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382846,1046607,90006,475341,557890,941085,797944,425535,823985,407908,619789,40643,1031654,654332,749537,404341,3824,848580,642214,921050,136977,159349,73927,382692,870795,225603,9075,694194,552705,54355,627755,116971,89229,16129,609128,437238,813619,859675,705199,815736,779079,746346,794683,845973,321031,523204,803841,128917,593128,399309,822026,484812,78165,602364,650462,375006,812580,298328,177077,597213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 864073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 864073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001239s ]