SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419450 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419450 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89075,426623,703366,653434,57560,665112,882665,759023,107387,873272,318320,347299,644681,667567,106489,1022990,700642,654997,225065,236908,975993,195811,997799,595985,647225,1011790,201079,205136,652072,63149,404308,398199,547315,698258,945261,832912,388601,674930,944349,1041352,672920,600280,207222,822393,610926,71324,113099,604991,363189,811704,897553,347482,372979,685697,679626,1035181,1005752,695122,741330,170105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]