SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314039 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314039 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253229,393729,126779,1046202,234850,468521,1036512,615002,167544,633448,14058,238629,101029,735390,941496,635555,611592,946687,242992,1018570,1023281,747311,186504,346771,957767,977387,966827,633155,220107,1179,987938,317994,331067,256999,734802,645264,642584,199105,590949,486554,462060,577763,320455,303661,483005,134671,979778,153214,971608,938688,744939,235726,986710,248317,297303,71972,47709,408861,555816,97814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]