SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394097 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394097 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641494,376971,791405,40980,1036758,943068,988556,491994,593908,199872,909902,862259,54210,865021,151422,51622,915464,511209,782661,759377,108400,137940,614247,326470,224310,542992,289453,488217,29648,1047303,220182,1025392,529827,419448,645705,242241,827379,576102,332012,755473,454461,82549,604651,588079,754774,31002,744160,800750,1044269,920361,576341,367213,183059,518743,664423,889642,491944,26614,779028,857495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]