SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101094 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101094 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218488,976569,363015,841184,517000,828130,106644,359189,214897,485066,748209,840164,139618,149606,246657,150109,1023696,435278,202099,1039049,682808,459482,633601,581459,136980,521097,392188,886206,203809,424210,738097,585826,846193,804858,659840,970181,779752,369314,447073,81984,547372,966191,50838,62939,458511,788584,932091,724299,161401,694210,703471,645397,404450,698669,928472,710448,493686,70586,380990,335769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002198s ]