SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478110 LIMIT 1 [ RunTime:0.004255s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478110 [ RunTime:0.005975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532202,49332,541849,812150,342347,945784,193542,732072,498875,834496,838763,900849,186368,200969,1038308,476075,383059,123356,981989,108730,987338,577177,1027758,979526,703054,458912,746021,151446,1024757,988748,119924,428806,1007328,13984,276544,406959,332243,208871,1048384,922292,360955,588552,100972,508972,166398,608918,244038,754897,713740,107962,363580,847814,1043816,697175,718337,907152,552062,809893,938369,372064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001064s ]