SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028435 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028435 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410167,376044,323006,703726,310289,854093,1005181,955897,265695,339872,425723,9722,847814,432541,239872,532021,722446,375429,639053,89758,381374,460523,30147,910630,928965,327488,802252,527573,699203,1021253,961888,29881,487941,904492,666785,793726,106955,144415,279224,894852,498894,415449,71367,762545,269184,196430,794852,958034,570742,409213,443322,27699,674244,49334,487098,782616,590461,271465,65448,156128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]