SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001787s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507683 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507683 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992330,1011970,512859,405507,510513,736132,123260,898485,686650,956144,640020,815511,1025710,277449,397105,496721,911527,816995,631748,676266,393424,133579,962156,892047,567101,420501,44302,648225,605592,261819,513093,952991,627816,831580,402017,496951,326441,936210,460157,242584,697782,1013885,417559,876743,152174,109698,134986,931266,429817,1016687,115139,744639,695450,845428,415700,395515,528201,662393,231847,203730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]