SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805610 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805610 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392843,475655,426564,371585,870329,962191,171993,558065,58640,462727,706258,354736,1026604,961328,1000930,106921,397389,652065,291159,84547,506424,345654,517011,867534,796436,769838,320478,1044559,722407,297392,22381,930894,346913,1004145,741296,1019826,543816,236050,862099,970408,306204,868052,827906,59070,699576,921115,1007383,417417,569871,411033,718206,662314,843242,288616,540337,33346,21618,235772,144352,565233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]