SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34004 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34004 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568816,382863,296723,987054,229185,612960,496771,612854,707813,863590,9577,808568,1001318,759364,408220,733979,667398,360322,363117,768672,844304,201076,470692,931878,765482,248503,991329,170931,32161,131467,533516,619292,110357,443407,1025741,307322,788160,457053,692806,400741,636971,706264,709101,130042,116321,857759,146759,99882,27035,1014491,808988,892964,584180,325883,945124,161032,647754,233774,887632,862672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]