SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474896 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474896 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911809,150743,748959,954078,636015,574366,1004062,649335,734431,754075,115527,377938,833767,474102,588353,103276,668740,1031683,182993,190555,244878,553161,327046,926979,485950,864719,1023742,1028891,243029,214175,970091,822180,417805,96695,626904,88381,367256,335484,450006,743755,837780,753552,171755,822582,556681,577063,681854,52864,85636,1036634,446686,185777,1022166,466535,844089,612398,334221,55172,736148,306135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]