SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820111 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820111 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924813,70919,979050,56161,103024,314928,336722,774051,878874,194197,666568,652101,83621,812100,290957,768891,480634,770019,252582,123495,333485,498885,181233,809855,451728,19516,367600,69693,142860,1034100,35223,247878,341144,108154,627905,466006,212052,239058,230893,694630,442610,741750,246397,706446,423724,245047,412144,942319,339621,710101,215846,316454,909007,1019005,466126,227568,118715,611673,909156,537020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]