SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403298 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403298 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138021,192049,263216,660653,1036078,408459,1010033,334917,653680,205239,367696,360841,462278,187843,3602,439305,782020,553568,609752,679144,281263,988253,651673,353621,948526,549608,716163,796623,593661,664801,538711,160816,562659,74945,62011,970239,955073,692007,128446,549236,505428,76560,1009258,110630,945318,532178,584020,711131,928729,1027632,415684,202248,2217,421636,755541,755921,713356,824529,374273,39114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]