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` = 596890 LIMIT 1 [ RunTime:0.000959s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596890 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726573,491910,494925,306651,229448,90594,179529,228514,1032035,171659,421592,698063,1015386,1004380,1011619,448012,306753,700103,858417,330330,405741,387619,324271,640020,710938,631051,56985,709255,128864,894647,387222,678862,4896,776720,635769,502437,745079,443831,262537,448948,658874,441066,694057,447524,791979,873443,595461,982182,327282,159089,135749,107405,991228,59050,213047,1023799,511976,418328,334875,620316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]