SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381246 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381246 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26250,436779,119599,292885,394602,156247,1048031,342122,446296,864445,1002580,424676,896402,732012,955600,437163,496489,466816,669517,523264,261469,457804,365377,794086,250401,829227,351865,381693,939327,882017,699525,779937,384935,293554,792264,303453,804144,582656,409738,20405,978301,228085,110335,952098,308446,170907,610757,1031810,99507,446553,586001,875613,165898,384781,449257,766434,1008973,889460,87648,779162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]