SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014648 LIMIT 1 [ RunTime:0.002795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014648 [ RunTime:0.004680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825357,561638,693483,824136,653422,436181,838444,595814,4257,836553,269920,769250,518941,249681,374163,1037185,236075,1041377,447434,907956,358457,1009424,302201,602188,986798,327873,110299,769158,255935,372176,372782,653619,253646,384500,134518,192108,870613,849505,490522,999773,452934,325586,183622,655686,308189,332780,353441,642189,897974,401807,946311,491058,630996,186219,584020,558671,43600,410693,957170,411642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]