SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428213 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428213 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200353,403256,660226,493526,662619,985450,659035,970408,283131,6364,144759,530118,1044234,334922,369371,233790,915877,893345,466259,134070,491381,351065,319951,110026,914641,114288,365190,309396,352139,546017,810136,72433,144971,82474,124787,93240,208031,80419,608336,348371,331151,570438,343725,56060,650450,774199,200731,982892,940771,732714,322523,88265,948024,28158,738752,510602,885720,354736,540444,385249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]