SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503731 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503731 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156938,711287,246866,987567,777665,994184,274400,795179,252567,132312,85475,115413,724246,470427,398846,494865,601723,422653,629642,314220,871862,315470,399310,559857,850949,334199,98082,147475,971760,646603,726657,675287,380157,704117,187055,602032,552291,396967,854104,400185,352357,930599,776944,129508,134662,482679,969705,553451,534129,431236,979089,884793,524824,366213,666943,634315,414307,712369,139762,525604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000953s ]