SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566251 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566251 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115441,968633,205349,927273,527683,591410,428778,669691,339798,94987,580196,872821,820943,984970,508138,315925,176097,533358,427392,797305,801282,656527,347758,166445,443798,228229,46234,273019,247614,607649,801378,405451,543165,1014949,945332,520075,855429,239079,825190,224177,811029,609210,518349,837332,399444,203216,834500,54607,763732,978576,45092,221656,1021825,16334,922500,77538,133654,320805,100763,435292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]