SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577271 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577271 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748821,89788,501543,755418,776719,876172,1604,970871,433513,791316,501410,157134,940035,886910,633473,839850,97487,320948,656068,170607,444744,605632,327024,95994,296296,737027,713184,452871,472907,254451,173785,774059,313525,932757,149944,907116,444263,987430,390189,164346,393946,573767,209552,130411,869751,429771,286564,897857,139914,1012500,1008425,730377,280843,1031225,312765,20714,667178,454450,544882,808568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]