SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034183 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034183 [ RunTime:0.004826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848511,900815,504023,734271,931945,749862,860868,26933,397792,174114,113390,180730,532093,846659,567521,847031,432103,180845,656590,779474,719399,16801,40825,812926,10914,544325,415674,633412,533739,948747,226059,328027,662682,507959,599803,633705,544908,468602,981754,465643,493893,830435,303019,567188,1021533,813067,624458,1042763,366062,102939,85596,200746,300474,1022758,900311,493573,754689,198256,47769,497575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]