SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 948201 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 948201 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638180,971484,415052,778245,306711,595509,338301,238949,382739,152982,901034,358269,759451,479282,163560,412882,235310,31630,605834,342826,667793,507418,597296,745569,335960,451573,198509,2584,984026,609861,600101,125119,483401,354900,646742,891478,581961,560083,1028431,392537,964363,39474,174931,108319,1038968,1047260,345156,265176,479534,270006,138470,427501,324416,494469,1004525,665838,1014040,680337,172301,457403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 948201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 948201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]