SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014528 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014528 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405076,179937,291367,174669,14242,1018127,736731,1010098,934621,396405,231640,240713,466243,819781,860913,89254,150823,924106,627796,301830,333412,759244,370427,562934,740207,373331,195159,438885,305773,464668,873322,1005500,199877,399213,481003,721013,505703,958983,512246,784384,955908,288610,532448,839064,290284,57159,974691,203334,36436,1018738,144420,529992,779397,614748,114752,755359,462959,366975,931806,406084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]