SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199360 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199360 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311094,181343,1006565,672361,219577,275020,415311,316931,566297,330599,38866,822182,516344,536286,292777,779225,578839,1048014,532148,531962,302237,312319,742074,459143,947055,80460,528750,435886,450011,49810,599147,335617,1042168,21388,39905,5716,992305,371719,963061,41039,64073,635221,809562,581908,26869,100750,624741,271302,1027678,347204,798785,228506,906203,614727,925262,1015374,165936,1019231,224312,242090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]