SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516072 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516072 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462188,885050,1041617,765984,711112,510214,995733,699955,650581,453590,640606,82522,868683,917968,764360,369288,322389,774006,932214,380869,185487,455230,489741,743254,547533,889670,1026996,60275,100152,659334,56108,849542,403278,937340,197953,39956,448122,344781,778031,630764,586930,1024165,762644,897690,685097,493370,1000776,88818,208018,902320,577311,512885,800282,84801,2329,25516,927887,813868,939733,724052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]