SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540021 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540021 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155266,569252,132055,920575,425259,1029637,830730,1019749,826502,232544,667974,777904,855862,207253,410013,320869,311189,143208,796953,350810,242207,444081,56336,487385,152873,887972,11956,215948,714220,628501,388534,455104,425180,185699,866558,247203,378102,935634,118555,193675,146483,1013386,630949,369634,630273,486611,936365,298486,750233,675728,814294,61257,1009479,115274,821739,1047366,97486,394622,659739,781192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]