SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019023 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019023 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282101,640329,349141,89847,571114,882731,269041,916835,959689,510927,760814,39467,44632,550620,938924,228551,557850,934846,964923,831657,883987,751977,375264,1019539,249494,1035859,304884,128815,806432,313840,249776,194389,510817,196252,516626,823360,1045961,828015,326548,253318,574111,189617,277707,820940,975345,1023935,382526,4642,50741,235817,1022675,271847,429049,229907,865911,173217,670942,691071,713752,553889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]