SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585840 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585840 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577048,733539,826578,953932,285787,137201,878430,468313,827293,221632,424134,847789,578941,444434,305776,727765,999183,77825,797384,665589,917100,958392,709923,846056,260556,437671,583193,510569,234552,281774,92096,294958,853442,538972,259108,627864,774235,844742,968047,144248,155972,356222,596387,799814,21413,131807,222853,905216,436034,931718,652498,100934,270653,827906,440225,1023407,378560,937525,533514,370274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]