SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307118 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307118 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127097,523864,806460,572393,778074,763625,379622,719660,781058,857439,746850,234949,712684,91754,584544,1008793,718892,894535,36664,672374,372806,147096,995480,645609,858762,208777,224319,415580,1031810,589400,851508,816343,334252,938798,361847,199453,914011,382952,895015,748903,434403,628429,115201,128983,682531,62451,482545,968224,790771,329076,194761,535652,190740,561206,644553,932343,178976,991128,194354,259652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]