SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328001 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328001 [ RunTime:0.003060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033773,279785,379620,209447,498936,600577,3027,503124,437876,916799,736811,38900,778597,936110,962967,399394,7533,16700,989235,1014342,856897,879732,537393,237062,11735,1030936,619731,157919,537798,1036229,365358,214862,1037990,746860,45364,928472,566445,454701,349486,75009,1031879,494991,821548,259062,235953,861438,705219,794058,848303,599470,468661,982045,445782,1037139,1047896,30483,839668,73998,414657,479124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]