SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393475 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393475 [ RunTime:0.007534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948435,847916,97658,1010916,95806,413194,277767,909326,1024557,643214,227127,256410,658473,319286,1009341,432420,354149,492582,1026719,313356,128062,417286,69026,938328,858144,687184,972975,4724,909199,323122,185690,471162,456252,371478,176808,632909,873378,434217,777330,870829,811763,494377,269897,511291,490417,657940,643943,322179,376212,356819,184181,952369,275052,121138,522205,1015546,414756,777163,387457,389422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001146s ]