SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414063 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414063 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433737,632524,109707,855610,491069,966508,128421,707007,307573,33984,17270,265711,354616,85939,69723,185554,1040389,222232,171670,694767,964349,155242,373423,163938,657458,439670,777194,961489,92590,858125,401097,589037,329027,12653,204223,953566,910575,953758,159317,377338,126733,962898,15750,415511,589906,825950,807949,878023,1007119,796962,578177,110299,365684,120538,396044,781772,215417,847121,814671,151821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]