SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516383 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516383 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036506,1043704,803334,687236,14162,504714,915714,938783,890713,520337,1034703,530368,26160,102867,395861,396185,636631,232516,130684,229536,449272,103845,982837,1037560,259126,636165,248469,135799,171229,310432,15411,767839,900427,546014,287668,878446,862826,352100,977913,55780,905739,211777,100177,786686,350850,309770,838558,750200,833304,728203,190210,970877,79754,32604,274197,850622,708349,76092,520477,894012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]