SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426036 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426036 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62518,10699,644208,534818,292585,929917,358573,178034,144588,386783,538195,677125,376435,994260,738839,854703,533893,175103,124964,99745,721342,867260,746380,590290,1004326,756685,497547,700191,485730,831840,459792,723058,94009,14211,1017719,679513,51341,859160,630736,55358,592535,321324,397857,554803,1009243,610957,840908,777155,529646,10655,642835,180395,416923,856913,488140,402448,602550,657047,392778,373163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]