SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43860 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43860 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714879,155596,156252,438825,927987,105438,515129,701015,579900,20528,486015,556318,270824,804565,530091,536322,293977,163644,505093,89882,981814,542903,353433,1044489,247274,283519,558188,177356,444660,89415,47330,662453,372764,761665,749383,538953,953989,93380,583107,683654,617289,636514,303598,178733,888303,180134,157578,305247,46520,225865,728466,178314,294396,982892,441256,943309,41381,66108,812616,386056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]