SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262846 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262846 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111395,788610,345398,744284,791211,865463,678270,827777,516017,343244,116904,296353,140267,551525,231863,641797,5226,357724,466554,461943,482876,72137,886701,780086,536440,62761,723455,905881,1017344,503744,53108,94545,1039635,18924,395940,174740,1011237,836735,49166,350159,767303,745897,34177,16576,516942,523402,847306,499144,915016,162223,751933,1023416,802953,948519,693644,804288,1041426,183181,359648,310337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]