SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402919 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402919 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487241,840240,1016296,795727,125294,8686,782565,487492,289339,807285,755872,988326,177101,242241,559451,367714,476042,829997,70495,130487,498201,619743,548586,72219,149890,792328,581022,772192,753289,640608,961460,578664,393828,536017,524555,657762,395758,454,474646,834524,793971,208439,871947,160423,816356,49775,456384,943631,139133,885151,240938,532062,940447,545082,248449,645276,50712,995951,616865,855155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000339s ]