SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422628 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422628 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265458,402424,509333,83490,933448,171403,380827,70184,438190,836609,741296,270344,225111,230389,425124,1048897,347943,797010,637380,875810,512140,952166,50967,284643,461067,975419,1000246,520260,252781,332328,1019362,407733,981566,551179,823892,623247,40544,408258,362937,266310,390588,342192,669974,285965,316833,578323,324115,255175,587398,975536,1017449,822695,721445,816075,784937,785256,246540,470529,584551,752234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]