SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496335 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496335 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505627,340939,1033968,564549,480368,426535,237580,726650,610660,171007,657615,591186,1010605,318538,854674,567259,347199,444286,331682,104833,586716,653589,1044652,385271,700583,238417,338593,1009253,603395,1000855,101499,320861,554551,551675,575164,880999,1025175,804359,744548,669874,325132,436565,764991,378268,480072,848874,329850,203312,82015,425923,1038950,333125,779729,190414,1035987,209055,146173,1036353,189766,1042918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]