SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522916 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522916 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226212,305947,818546,622753,125488,174929,223917,417127,301885,338968,959941,902678,112224,456279,10869,9019,708443,460769,745174,707376,110830,806324,271721,980720,890241,713345,483534,151680,818356,529399,273164,521291,204010,554269,844748,223368,448687,295085,316358,807115,240837,79598,347388,685292,383949,360200,797888,518498,945926,959969,878462,319355,453755,823332,969848,99617,90464,533300,249697,393502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]