SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042351 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042351 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122972,54836,799005,477073,636064,49154,645282,865436,285626,958465,136927,441380,6750,364660,687320,883729,26865,778584,579922,752372,241685,537703,617744,499779,679533,193871,561373,467327,477168,22336,18490,657665,433146,307868,1016972,1025135,716992,50111,354860,775158,832466,319490,1043695,510472,758914,262688,407023,882354,262203,305621,708736,120280,728709,217105,38052,537147,431421,2995,347161,398499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]