SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599600 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599600 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760183,1536,658874,403928,79594,652175,877474,381446,146566,752805,39189,1000036,782013,356736,753265,492787,362242,58224,368170,989621,744067,733731,471805,255872,1009403,1013000,924075,1776,13552,972401,307104,511089,205941,322842,47315,138017,685599,507788,676309,428566,281933,449987,1031888,327809,266336,795851,244059,345486,201893,470537,577647,610377,536122,868443,136472,681678,699311,189939,871084,615735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]