SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550470 LIMIT 1 [ RunTime:0.000940s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550470 [ RunTime:0.002352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955520,234334,931181,205475,210884,343775,221586,273808,340199,366145,209982,466581,12059,775096,259939,220942,706630,559732,335867,582938,360793,673035,273619,1027337,8117,508137,721837,592675,189284,864929,308832,294952,531383,54155,421200,591598,877485,363946,451767,69376,983523,288207,758718,585811,1000707,982747,877288,386864,706197,1025292,675696,181201,17491,737525,681354,268659,399569,988861,1040556,24914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]