SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346791 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346791 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559754,1022744,783730,10946,436366,480531,351467,395270,950798,1018565,228897,231117,713987,805663,178587,859464,650248,844527,5481,678771,190644,54563,149739,983638,757376,529947,429774,280646,924776,868692,927439,962330,3175,375792,1025015,171260,795982,697406,41781,68203,131863,93448,99788,701571,108027,306953,1028854,967297,160407,9023,197653,407930,538320,739740,968897,665398,475040,649599,110262,45841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]