SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529528 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529528 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156186,41661,695111,296345,36197,380404,141577,182949,346651,69128,524936,543228,361899,926220,708136,715210,969996,526419,525776,349963,1030059,451651,573453,543284,746778,555935,601391,702356,77733,482545,888573,495149,386061,135605,642285,610685,828764,408200,213309,300501,979248,154453,75188,881366,791560,669531,648243,362309,364850,370190,49328,429224,719453,348385,999906,524817,644507,317282,952460,295333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]