SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428915 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428915 [ RunTime:0.002247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824254,115761,72372,959694,441076,832477,933073,262270,444591,334996,472224,483259,201078,273814,195959,312505,170142,761181,641767,806144,1014184,909175,217138,685849,154911,909635,629650,143545,52288,974833,381246,167251,272172,864630,962733,971543,773724,556131,225160,907895,647785,993720,603439,871852,695974,850166,44117,527431,184694,111641,208527,995236,267109,987009,16402,587026,460298,6737,630805,733568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001855s ]