SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022705 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022705 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35520,855626,1012592,699778,806096,243511,850665,282820,930553,625961,33984,504698,965462,283147,1003445,415490,726917,355621,518097,98975,142109,91588,1002145,365274,943228,940675,312471,775162,752677,895285,430333,988209,161082,451560,42102,204942,710448,881610,970422,1047176,151978,231862,942321,395506,810600,863234,475871,572759,457379,171887,566748,212901,569523,556256,886570,686386,981844,1000784,357246,203548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]