SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534579 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534579 [ RunTime:0.006264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736993,81811,199817,937671,162523,119794,190434,572120,386524,392945,127434,520730,422170,187984,92906,25521,420442,55264,143358,645282,863782,916807,642887,448531,610758,814700,276237,994254,453869,774984,1009610,343526,390264,597024,710825,801822,950278,855767,844738,149941,911751,764618,922253,113914,938820,270145,398131,206239,465989,400921,165781,259965,698600,276277,363142,318112,54254,639031,1027188,1007038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]