SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981804 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981804 [ RunTime:0.004258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228247,1018003,1016209,570042,614033,146457,247522,677599,296522,1034315,320538,673477,326040,499043,366736,414851,335797,717017,922909,463535,838993,41807,543513,443150,89749,411779,607079,876434,665632,7758,305050,414026,343233,626751,7207,321206,860488,1019210,317899,163087,565153,706128,769267,940651,433273,142339,151829,499113,449398,748299,274039,323742,513607,113445,673870,641220,987354,86944,929962,451380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]