SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140923 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140923 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598051,580904,983604,457049,666960,703733,367797,68582,236234,314978,732631,480471,899875,185130,503526,404535,124682,14237,303020,511697,424687,739005,62670,335515,774275,202169,1009123,622803,667314,459884,1037535,420988,1007242,905618,454652,983921,988756,431980,371648,233943,290180,378353,748768,301746,259706,350279,148329,791200,830086,348396,3142,23913,892982,370864,716233,186910,718300,924372,121106,35519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005505s ]