SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820140 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820140 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749243,731124,302279,456930,840973,722013,592320,463285,171552,29179,96032,215496,406681,109916,133758,321457,497943,776956,10145,412414,80618,79007,290899,398277,607710,602700,208573,961677,352304,741111,713352,113972,1014164,995840,815948,555071,778858,475579,13206,644925,217817,354597,1043693,925721,863607,203594,39419,97588,644286,203288,749798,166387,130295,630745,1039307,338356,394096,486692,517227,901085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]