SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104045 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104045 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929319,268130,381529,505438,426503,43199,217628,970927,184477,437529,808983,964959,547851,672478,1035259,130899,180829,960675,509679,101647,1022512,857177,289522,563569,322929,748236,37168,381933,2206,494286,663018,204176,393759,727895,674719,1004585,438662,274360,601956,53554,305078,234491,415671,811582,706534,373499,457892,92740,493536,656421,365893,775798,147593,704797,948295,970847,444633,141529,495125,253344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]